﻿using System;
using System.Collections.Generic;
using System.Web;

namespace FOBTV.Web.DBUtility
{
	interface IDBHelper
	{
		void Close();
		string ConnectionKey { get; set; }
		string ConnectionString { get; set; }
		System.Data.OleDb.OleDbConnection DbConn();
		bool ExecuteBoolWithCommand(string CommandText, params System.Data.IDataParameter[] Parameters);
		System.Data.DataSet ExecuteDataSetWithCommand(string CommandText, params System.Data.IDataParameter[] Parameters);
		System.Data.DataTable ExecuteDataTableWithCommand(string CommandText, params System.Data.IDataParameter[] Parameters);
		int ExecuteNonQueryWithCommand(string CommandText, params System.Data.IDataParameter[] Parameters);
		object ExecuteScalar(string SQL);
		object ExecuteScalarWithCommand(string CommandText, params System.Data.IDataParameter[] Parameters);
		bool ExecuteSqlCommand(System.Data.IDbCommand cmd);
		bool ExecuteSQLNonquery(string SQL);
		int GetRecordCount(string TableName, string WhereClause);
		System.Data.DataSet SelectToDataSet(string SQL);
		System.Data.DataSet SelectToDataSet(string SQL, string subtableName, System.Data.DataSet DataSetName);
		System.Data.DataTable SelectToDataTable(string SQL);
		System.Data.OleDb.OleDbDataAdapter SelectToOleDbDataAdapter(string SQL);
	}
}